Calculation Engine Samples
Fastest and most complete Excel compatible calculations without Excel
Excel Calculation Samples The true power of SpreadsheetGear for .NET is realized when using its superior Microsoft Excel compatible calculation engine. Its unmatched performance and accuracy provide a competitive advantage to data critical Windows Forms and ASP.NET applications. The following samples show various ways to utilize the spreadsheet calculation engine to manipulate data in a windows forms project. These examples are easily adaptable to many Microsoft .NET Framework solutions.
Formula Evaluation
Demonstrates evaluating a single Excel compatible formula entered into a windows form.
Simple Loan Calculator
Demonstrates calculating a loan payment based on input from a windows form. By using this design pattern, you can easily deploy complex numeric, financial and statistics calculators which call on the full power of SpreadsheetGear for .NET's Microsoft Excel compatible calculation capabilities.
Amortization Calculator
Extends the Simple Loan Calculator with an amortization table which is displayed in a WorkbookView control. Of particular interest is the use of the defined name, AmortizationTableForNPer, which uses the OFFSET() worksheet function to return a dynamically sized range.
Custom Functions
Demonstrates creating your own custom functions in the Microsoft .NET Framework and adding them to a workbook set. The worksheet formulas which utilize these custom functions are compatible with Microsoft Excel worksheet formulas which utilize VBA or XLL custom functions.